Create Graded Category KPI Cards 20

Step 1: Create Sub vs Graded

- Copy and Paste Avg Non Graded Days

- Change Indicator to Sub vs Graded and Target goals to Sub vs Graded goal

- Select Format under general X position = 592, Y position = 145, Width = 289, Height = 160

- Color coding = High is good

- Title = Sub vs Graded

- Format Sub vs Graded and Sub vs Graded goal to a percentage.





Step 2: Create KPI background

- Select Format from top pane, then choose selection, choose Average of Non Graded Days

- Copy and Paste Avg. Non graded days background

- Move to align with new KPI card

- Change values to Sub vs Graded




Step 3: Create Sub vs Non Graded

- Copy and Paste Sub vs Graded

- Change Indicator to Sub vs Non Graded and Target goals to Sub vs Non Graded goal

- Select Format under general X position = 592, Y position = 347, Width = 289, Height = 160

- Color coding = Low is good

- Title = Sub vs Graded

- Format Sub vs Non Graded and Sub vs Non Graded goal to a percentage.




Step 4: Create KPI background

- Select Format from top pane, then choose selection, choose Sub vs Ungraded by Rolling weeks

- Copy and Paste Sub vs Ungraded by Rolling weeks background

- Move to align with new KPI card

- Change values to Sub vs Ungraded by rolling weeks





Step 5: Create Avg Days to Grade

- Copy and Paste Sub vs Non Graded

- Change Indicator to Avg Days to Grade and Target goals to Avg Days to Grade Goal

- Select Format under general X position = 592, Y position = 550, Width = 289, Height = 160

- Color coding = Low is good

- Title =Avg Days to Grade




Step 6: Create KPI background

- Select Format from top pane, then choose selection, choose Sub vs Ungraded by Rolling weeks

- Copy and Paste Sub vs Ungraded by Rolling weeks background

- Move to align with new KPI card

- Change values to Avg Days to Grade





Creating KPI cards .

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-kpi#:~:text=How%20to%20create%20a%20KPI%201%20Open%20the,order%20by%20FiscalMonth.%206%20Important%20More%20items...%20